-
Re: Unique ID Formula
@SPBops You would have to evaluate the number and then add the leading zeros with a formula. In this scenario, the cleanest way to do it would probably be to evaluate the number while you are doing t…1 · -
Re: Formula to return a calculated value, only if the value in another column is not zero
That is odd. I recreated your columns and it does not do that for me. Can you confirm that all of your @row mentions in the formula have a color to them (not black text) to verify that Smartsheet can…1 · -
Re: Formula to return a calculated value, only if the value in another column is not zero
It shouldn't. I would check the column formatting, just to make sure that everything is set to Text/Number, but other than that it all looks fine and matches what I have working on my test sheet.1 · -
Re: Can you stop automations from running on completed projects?
When you speak of global updates, does that mean you have Control Center? If so, they best way to do this would be with the archiving process. Through archiving your completed projects you can do thi…1 · -
Re: Hi - I need help with this formula. I am getting UNPARSEABLE error with it each time
Very close Suumit. I think the only issue in what you have is that you need to make the next nested IF statement the FALSE part of your first if statement instead of a new statement entirely. So it w…1 ·